package com.ruoyi.system.service;

import com.ruoyi.system.domain.EarthQuery;
import com.ruoyi.system.domain.TheGeography;

import java.util.List;
import java.util.Map;

/**
 * geographyService接口
 *
 * @author ruoyi
 * @date 2023-04-17
 */
public interface ITheGeographyService
{
    /**
     * 查询geography
     *
     * @param id geography主键
     * @return geography
     */
    public TheGeography selectTheGeographyById(Long id);

    /**
     * 查询geography列表
     *
     * @param theGeography geography
     * @return geography集合
     */
    public List<TheGeography> selectTheGeographyList(TheGeography theGeography);

    /**
     * 新增geography
     *
     * @param theGeography geography
     * @return 结果
     */
    public int insertTheGeography(TheGeography theGeography);

    /**
     * 修改geography
     *
     * @param theGeography geography
     * @return 结果
     */
    public int updateTheGeography(TheGeography theGeography);

    /**
     * 批量删除geography
     *
     * @param ids 需要删除的geography主键集合
     * @return 结果
     */
    public int deleteTheGeographyByIds(Long[] ids);

    /**
     * 删除geography信息
     *
     * @param id geography主键
     * @return 结果
     */
    public int deleteTheGeographyById(Long id);

    void readCsv(String filePath) throws Exception;

    List<List<String>> getYear(EarthQuery query);

    List<List<String>> getMonth(EarthQuery query);

    List<List<String>> getDay(EarthQuery query);

    List<Map<String, String>> getType();

    List<Object []> getSet();

    void setCity();

    List<Map<String, Object>> selectCity(EarthQuery query);

    List<List<String>> getCity(EarthQuery query);
}
